Bar: Household Income vs YoY, Reset 16

House hold Income vs YoY

Click New Worksheet, Rename 'House hold Income vs YoY', Double click title to edit, Size 11, Bold.


Create Bar chart and YoY

Drag and drop Incom brackets in Columns and Household Income in Rows,  Bring cc. YoY Applicants and cc. YoY Units Available to the right axis, Change Marks (SUM(Household Income) to Bar and Measure Values to Line), Fit Entire View, Edit Color --> (House hold Income   - #aa557f ),  Hide header.

See gif




Format and Tooltip

Select ALL, Drag YoY Applicants and YoY Units to Tooltip, Click Tooltip Add    

Income Brackets: <cc.Income Brackets>

Household Income: <SUM(Household Income)>

YoY Units Available: <AGG(cc.YoY Units Available)>

YoY Applicants: <AGG(cc.YoY Applicants)>  

Format Chart 

See gif






RESET Button

New Worksheet, Rename 'Reset'

See gif




Combination Charts: https://www.youtube.com/watch?v=Ymtc2iHIjwk&t=276s